<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%> <%@ page import="java.sql.*" %> <%@ include file="/common.inc" %> <%@ include file="/login_check.inc" %> <% // POST 한글 파라미터 깨짐 처리 request.setCharacterEncoding("UTF-8"); // 사용할 객체 초기화 Connection conn = null; PreparedStatement pstmt = null; // 파라미터 String seq = request.getParameter("seq"); try { // 데이터베이스 객체 생성 Class.forName("com.mysql.jdbc.Driver"); conn = DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/ys", "srpinfotec", "srpinfotec1@#"); // pstmt = conn.prepareStatement("DELETE FROM NOTICE where seq = ? "); // pstmt.setInt(1, Integer.parseInt(seq)); pstmt = conn.prepareStatement("UPDATE NOTICE SET delete_yn = 'Y', delete_user_id = ? WHERE seq = ? "); // pstmt = conn.prepareStatement("UPDATE NOTICE SET title = ?, contents = ?, file_nm = ? where seq = ? "); pstmt.setString(1, session_user_id); pstmt.setInt(2, Integer.parseInt(seq)); pstmt.executeUpdate(); } catch (Exception e) { e.printStackTrace(); } finally { System.out.println(pstmt.toString()); if (pstmt != null) pstmt.close(); if (conn != null) conn.close(); response.sendRedirect("notice_list.jsp?main_seq="+main_seq+"&sub_seq="+sub_seq+"&sub_sub_seq="+sub_sub_seq); } %>